﻿

if col_length('Cart', 'DiscountTotalWithTax') is null
Begin
	alter table dbo.Cart Add DiscountTotalWithTax bigint null
End
Go

Update dbo.Cart
Set DiscountTotalWithTax = 0
where DiscountTotalWithTax is null
Go

alter table dbo.Cart alter column DiscountTotalWithTax bigint not null
Go

if col_length('Cart', 'DiscountReason') is null
Begin
	alter table dbo.Cart Add DiscountReason varchar(120) null
End
Go


